package com.uwaterloo.interviewme.common;

/**
 * The Interface DBConstants.
 */
public interface DBConstants {
	// Columns for InterviewModel
	/** The RO w_ id. */
	String ROW_ID = "rowID";
	
	/** The ID. */
	String ID = "_id";
	
	/** The CNAME. */
	String CNAME = "companyName";
	
	/** The POSITION. */
	String POSITION = "position";
	
	/** The LOCATION. */
	String LOCATION = "location";
	
	/** The TIME. */
	String TIME = "time";

	// Columns for DetailInfo
	/** The TYPE. */
	String TYPE = "type";
	
	/** The STATUS. */
	String STATUS = "status";
	
	/** The LENGTH. */
	String LENGTH = "length";
	
	/** The JDESC. */
	String JDESC = "jobDesc";
	
	/** The DATABASE name. */
	String DATABASE_NAME = "InterviewMe";
	
	/** The DATABAS e_ table. */
	String DATABASE_TABLE = "Interview";
	
	/** The DATABAS e_ version. */
	int DATABASE_VERSION = 2;
	
	/** The NA. */
	String NA ="Not Available";

	/** The DATABASE create query. */
	String DATABASE_CREATE = "create table Interview (_id text primary key, "
			+ "companyName text not null, position text not null, location text not null, time text not null, "
			+ "type text, status text, length text, jobDesc text);";
}
